package com.ruoyi.system.mapper;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.ruoyi.system.domain.*;
import org.apache.ibatis.annotations.Param;
import org.springframework.web.bind.annotation.RequestParam;

/**
 * 房屋产权信息
 * Mapper接口
 *
 * @author ruoyi
 * @date 2021-04-01
 */
public interface TmcHouseInfoMapper {
    /**
     * 查询房屋产权信息
     *
     * @param id 房屋产权信息
     *           ID
     * @return 房屋产权信息
     */
    public TmcUserHouse selectTmcHouseInfoById(Long id);

    /**
     * 查询房屋产权信息
     * 列表
     *
     * @param tmcUserHouse 房屋产权信息
     * @return 房屋产权信息
     * 集合
     */
    public List<TmcUserHouse> selectTmcHouseInfoList(TmcUserHouse tmcUserHouse);

    /**
     * 查询公司信息
     * 列表
     *
     * @return 公司信息
     * 集合
     */
    public List<Dept> queryDept();

    /**
     * 新增房屋产权信息
     *
     * @param tmcUserHouse 房屋产权信息
     * @return 结果
     */
    public int insertTmcHouseInfo(TmcUserHouse tmcUserHouse);

    /**
     * 修改房屋产权信息
     *
     * @param tmcUserHouse 房屋产权信息
     * @return 结果
     */
    public int updateTmcHouseInfo(TmcUserHouse tmcUserHouse);

    /**
     * 删除房屋产权信息
     *
     * @param id 房屋产权信息
     *           ID
     * @return 结果
     */
    public int deleteTmcHouseInfoById(Long id);

    /**
     * 批量删除房屋产权信息
     *
     * @param ids 需要删除的数据ID
     * @return 结果
     */
    public int deleteTmcHouseInfoByIds(Long[] ids);

    int selectCarnum(Map map);

    /**
     * 查询房屋物业费管理列表
     *
     * @param userID, houseID 房屋物业费管理
     * @return 房屋物业费管理集合
     */
    public List<TmcHouseBill> selectTmcHouseBillList(@Param("userID") Long userID, @Param("houseID") Long houseID);

    public TmcHouseBill selectTmcHouseBill(@Param("userID") Long userID, @Param("houseID") Long houseID);

    public TmcHouseBill selectTmcHouseBillById(Long id);

    List<TmcHouseSubbill> selectTmcHouseSubbillById(Long id);

    int updateUserHouseBillInfo(String recordID);


    int updateNum(String out_trade_no);


    public int updateUserHouseBillInfoByid(Long id);
    public Long querySumbyMouthY(HashMap map);
    public Long querySumbyMouthN(HashMap map);
    //校验
    int queryhousernum(TmcUserHouse tmcUserHouse);

    List<TmcHouseBill> queryTmcHouseBillList(TmcHouseBill tmcHouseBill);
}
